<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<title>Supported SQL</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="generator" content="Doc-O-Matic" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link rel="STYLESHEET" href="default.css" type="text/css" />

<script type="text/javascript" src="scripts.js"></script>
</head>
<body class="Element700" onload="onBodyLoadEx('frames.html', 'topic', 'Supported_SQL.html');" onmousedown="onBodyMouseDown();">

<!-- Begin Popups -->

<!-- End Popups -->

<!-- Begin Page Header -->
<div class="Element710" id="areafixed">
<div class="Element94">
<em>You are here:</em> <a href="Supported_SQL.html" target="topic">Supported SQL</a></div>
<div class="Element92">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="50%">
<div class="Element2">
<a href="contents.html" target="tocidx"><img src="btn_globals_contents_midblue.gif" border="0" alt="Contents" title="Contents" onmouseover="switchImage(this, 'btn_globals_contents_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_contents_midblue.gif');"></a><a href="idx.html" target="tocidx"><img src="btn_globals_index_midblue.gif" border="0" alt="Index" title="Index" onmouseover="switchImage(this, 'btn_globals_index_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_index_midblue.gif');"></a><a href="index.html" target="topic"><img src="btn_globals_home_midblue.gif" border="0" alt="Home" title="Home" onmouseover="switchImage(this, 'btn_globals_home_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_home_midblue.gif');"></a></div>
</td><td width="50%">
<div class="Element90">
<a href="COM_VERSION.html" target="topic"><img src="btn_prev_midblue.gif" border="0" alt="Previous" title="Previous" onmouseover="switchImage(this, 'btn_prev_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_prev_midblue.gif');"></a><img src="btn_up_d.gif" border="0" alt="Up" title="Up"><a href="Installation.html" target="topic"><img src="btn_next_midblue.gif" border="0" alt="Next" title="Next" onmouseover="switchImage(this, 'btn_next_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_next_midblue.gif');"></a></div>
</td></tr></table><div class="Element5">
Supported SQL</div>
</div>
</div>

<!-- End Page Header -->

<!-- Begin Client Area -->
<div class="Element720" id="areascroll">
<div class="Element721">

<!-- Begin Page Content -->
<div class="Element58">
<a name="Description"></a><div class="Element11">
<div class="Element10">
<p class="Element10">
This SQL parser is updated quickly, so the best way to check whether a sql is supported is to write a simple application with parse function to check it.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Data type:</div>
<p class="Element10">
character: char,varchar2,nchar,nvarchar2&nbsp;</p>
<p class="Element10">
Number: number, integer,int,small,float,double,real,numberic,decimal,dec&nbsp;</p>
<p class="Element10">
Datetime: date, timestamp, interval year to month, interval day to second&nbsp;</p>
<p class="Element10">
Long and raw : long, long raw , raw&nbsp;</p>
<p class="Element10">
Large object: blob, clob, nclob,bfile&nbsp;</p>
<p class="Element10">
Rowid: rowid, urowid&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Expression:</div>
<p class="Element10">
Math Operator: + - * /&nbsp;</p>
<p class="Element10">
Concatenation operator: ||&nbsp;</p>
<p class="Element10">
Supported function: case, decode&nbsp;</p>
<p class="Element10">
Logical operator: and, or, not, is [not] null, [not] in , between,&nbsp;</p>
<p class="Element10">
exists,like, = , != , &lt;&gt;, &gt;,&lt;, &gt;=, =&lt;, any ,some, all&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Select:</div>
<p class="Element10">
SELECT [ hint ] [ { DISTINCT | UNIQUE } | ALL ]&nbsp;</p>
<p class="Element10">
[ { TOP integer | TOP integer PERCENT } [ WITH TIES ] ]&nbsp;</p>
<p class="Element10">
target_list&nbsp;</p>
<p class="Element10">
FROM table_ref [, table_ref]...&nbsp;</p>
<p class="Element10">
[ WHERE condition ]&nbsp;</p>
<p class="Element10">
[ group_by_clause ]&nbsp;</p>
<p class="Element10">
[ HAVING condition ]&nbsp;</p>
<p class="Element10">
[ { UNION | UNION ALL | INTERSECT | MINUS } ( subquery )]&nbsp;</p>
<p class="Element10">
[ order_by_clause ]&nbsp;</p>
<p class="Element10">
[LIMIT { number | ALL }] [OFFSET number]&nbsp;</p>
<p class="Element10">
[ for_update_clause ];&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Insert:</div>
<p class="Element10">
INSERT_INTO {table_reference | (subquery)}&nbsp;</p>
<p class="Element10">
[(column_name [, column_name]...)]&nbsp;</p>
<p class="Element10">
{VALUES (sql_expression [, sql_expression]...) | (subquery)}&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Update:</div>
<p class="Element10">
UPDATE {table_reference | (subquery)} [alias]&nbsp;</p>
<p class="Element10">
SET&nbsp;</p>
<p class="Element10">
{column_name = {sql_expression | (subquery)}&nbsp;</p>
<p class="Element10">
|(column_name [, column_name]...) = (subquery)}&nbsp;</p>
<p class="Element10">
[, {column_name = {sql_expression | (subquery)}&nbsp;</p>
<p class="Element10">
|(column_name [, column_name]...) = (subquery)}]...&nbsp;</p>
<p class="Element10">
[WHERE search_condition]&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Delete:</div>
<p class="Element10">
DELETE [FROM] {table_reference | (subquery)} [alias]&nbsp;</p>
<p class="Element10">
[WHERE {search_condition }];&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Create table:</div>
<p class="Element10">
CREATE [GLOBAL TEMPORARY] TABLE [schema .] table&nbsp;</p>
<p class="Element10">
( column datatype [DEFAULT expr]&nbsp;</p>
<p class="Element10">
[ inline_constraint [inline_constraint]... ] | [out_of_line_constraintt ]&nbsp;</p>
<p class="Element10">
[, column datatype [DEFAULT expr]&nbsp;</p>
<p class="Element10">
[ inline_constraint [inline_constraint]... ] | [out_of_line_constraintt ]&nbsp;</p>
<p class="Element10">
]...&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
inline_constraint:</div>
<p class="Element10">
[CONSTRAINT constraint_name]&nbsp;</p>
<p class="Element10">
{ [NOT] NULL&nbsp;</p>
<p class="Element10">
| UNIQUE&nbsp;</p>
<p class="Element10">
| PRIMARY KEY&nbsp;</p>
<p class="Element10">
| references_clause&nbsp;</p>
<p class="Element10">
| CHECK ( condition )&nbsp;</p>
<p class="Element10">
} [constraint_state]&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
out_of_line_constraint:</div>
<p class="Element10">
[CONSTRAINT constraint_name]&nbsp;</p>
<p class="Element10">
{ UNIQUE ( column [, column]... )&nbsp;</p>
<p class="Element10">
| PRIMARY KEY ( column [, column]...&nbsp;</p>
<p class="Element10">
| FOREIGN KEY ( column [, column]... references_clause&nbsp;</p>
<p class="Element10">
| CHECK ( condition )&nbsp;</p>
<p class="Element10">
} [constraint_state]&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Create Index:</div>
<p class="Element10">
CREATE [ UNIQUE | BITMAP ] INDEX [schema .] index ON&nbsp;</p>
<p class="Element10">
[schema .] table [t_alias]&nbsp;</p>
<p class="Element10">
( index_expr [ ASC | DESC ] [, index_expr [ ASC | DESC ]]... )&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Create View:</div>
<p class="Element10">
CREATE [OR REPLACE] [[NO] FORCE] VIEW [schema .] view&nbsp;</p>
<p class="Element10">
AS subquery [subquery_restriction_clause];&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
subquery_restriction_clause:</div>
<p class="Element10">
WITH { READ ONLY | CHECK OPTION [CONSTRAINT constraint] }&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Drop table:</div>
<p class="Element10">
DROP TABLE [schema .] table [CASCADE CONSTRAINTS];&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Drop Index:</div>
<p class="Element10">
DROP INDEX [schema .] index [FORCE];&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Drop View:</div>
<p class="Element10">
DROP VIEW [schema .] view [CASCADE CONSTRAINTS];&nbsp;</p>
<p class="Element10">
&nbsp;</p><div class="Element15">
Oracle PL/SQL.</div>
<p class="Element10">
&nbsp;</p>
<div class="Element15">
MSSQL procedure and function.</div>
<p class="Element10">
&nbsp;</p>
<div class="Element15">
MySQL stored procedure.</div>
<p class="Element10">
&nbsp;</p>
<div class="Element15">
DB2 stored procedure.</div>
</div>
</div>
</div>
<!-- End Page Content -->

<!-- Begin Page Footer -->
<div class="Element93">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="100%">
<div class="Element3">
Gudu software http://www.sqlparser.com</div>
</td></tr><tr><td width="100%">
<div class="Element97">
Send <a href="#" onclick="sendFeedback('info@sqlparser.com', 'Documentation Feedback', 'Project: General SQL Parser Help file%0ATopic ID: Supported SQL%0ATitle: Supported SQL');">comments</a> about this topic.</div>
</td></tr></table></div>

<!-- End Page Footer -->
</div>
</div>

<!-- End Client Area -->
</body></html>